CREATE TABLE customer (
     email_address varchar(75) NOT NULL PRIMARY KEY,
     first_name varchar(50),
     last_name varchar(50),
     address1 varchar(50),
     address2 varchar(50),
     customer_zip varchar(10),
     area_code char(3),
     telephone_number char(7)
);
CREATE TABLE cardinfo (
     card_id int,
     ccnum varchar(16),
     ccexp date,
     name_on_card varchar(100),
     email_address varchar(75)
);
CREATE TABLE cardtype (
     card_id int NOT NULL PRIMARY KEY,
     card_type varchar(20)
);
CREATE TABLE locale (
     zip varchar(10) NOT NULL PRIMARY KEY,
     city varchar(50),
     state char(2)
);
CREATE TABLE manufacturer (
     id int NOT NULL PRIMARY KEY,
     name varchar(50),
     address varchar(50),
     zip varchar(10),
     area_code char(3),
     telephone_number char(7),
     contact_name varchar(50)
);
CREATE TABLE product (
     id int NOT NULL PRIMARY KEY,
     name varchar(50),
     price decimal(9,2),
     quantity integer,
     manu_id int
     cate_id int
);
CREATE TABLE producttype (
     id int NOT NULL PRIMARY KEY,
     category varchar(50)
);

